- Set of 250 movie data from IMDB
- (https://www.kaggle.com/datasets/yehorkorzh/imdb-top-250-movies)
IMDB Top 250 Movies
Variables
Numeric
- Num, Year, Released, Runtime, Metascore, imdbRating, imdbVote, imdbID
Text
- Title, Genre, Director, Writer, Actor, Plot, Language, Country, Awards, Type, DVD, BoxOffice, Production, Websites
DataMunging Pt1
Type Modification
- Runtime -> “123min”
- BoxOffice -> “$1,234,567”
- imdbVoting -> “1,234,567”
DataMunging Pt2
Data Split
- Genre -> “Drama, Action”
- Actor -> “Tim Robbins, Morgan Freeman”
- Writer -> “Mario Puzo (screenplay)”
- Language -> “English, Italian, Latin”
- Country -> “USA, UK”
- Awards -> “Won 3 Oscars. Another 23 wins & 27 nominations.”
DataMunging Pt3
Removed
- Released
- Plot
- imdbID
- Type
- DVD
- Website
DataMunging Pt4
Consistency and Completeness
## Num Title Year Runtime Director Writer ## 1.000 1.000 1.000 1.000 1.000 0.996 ## Metascore imdbRating imdbVotes BoxOffice Production First Actor ## 0.708 1.000 1.000 0.300 1.000 1.000 ## Second Actor Third Actor Fourth Actor Awards Nominations First Genre ## 1.000 1.000 1.000 1.000 1.000 1.000 ## Second Genre Third Genre l1 l2 l3 l4 ## 0.908 0.632 1.000 0.496 0.224 0.088 ## l5 l6 l7 c1 c2 c3 ## 0.032 0.012 0.004 1.000 0.296 0.088 ## c4 c5 c6 c7 c8 c9 ## 0.024 0.012 0.004 0.004 0.004 0.004
Exploratory Data Analysis
1D Analysis
- Observe characteristics of single variable
- Present all included variables
Year
- Mean: 1982.676, SD: 24.80921
Runtime
- Mean: 126.808, SD: 29.76338
Directors Pt1
- Unique Directors: 155
Directors Pt2
## x freq ## 4 Alfred Hitchcock 9 ## 9 Billy Wilder 7 ## 14 Charles Chaplin 5 ## 16 Christopher Nolan 7 ## 36 Frank Capra 4 ## 86 Martin Scorsese 7 ## 108 Quentin Tarantino 4 ## 115 Ridley Scott 4 ## 134 Stanley Kubrick 8 ## 136 Steven Spielberg 7
Directors Pt3
Writers Pt1
- Unique Writers: 213
## x freq ## 27 Charles Chaplin 5 ## 158 Quentin Tarantino 4 ## 185 Stanley Kubrick 6 ## 187 Stephen King 4
Writers Pt2
Metascore
- Mean: 80.0452, SD: 11.03034
imbdRating
- Mean: 8.244, SD: 0.2457347
imbdVotes
- Mean: 431401.3, SD: 367703.3
boxoffice
- Mean: 158727934, SD: 169133912
Production Pt1
- Unique Productions: 89
Production Pt2
## x freq ## 1 20th Century Fox 15 ## 9 Buena Vista Pictures 4 ## 11 Columbia Pictures 10 ## 41 MGM 9 ## 45 Miramax Films 7 ## 46 New Line Cinema 6 ## 55 Paramount Pictures 17 ## 62 Sony Pictures 5 ## 72 Twentieth Century Fox Home Entertainment 4 ## 73 United Artists 15 ## 78 Universal Pictures 14 ## 81 Walt Disney Pictures 8 ## 82 Warner Bros. 10 ## 83 Warner Bros. Pictures 27
Production Pt3
Actors and Actress Pt1
- Actors and Actress: 773
## x freq ## 10 Al Pacino 4 ## 97 Carrie Fisher 4 ## 101 Cary Grant 5 ## 106 Charles Chaplin 4 ## 120 Christian Bale 4 ## 281 Harrison Ford 7
Actors and Actress Pt2
Awards Pt1
- Mean: 29.44, SD: 40.12799
Awards Pt2
- 28 movies with 75 awards or more
## Title Awards imdbRating ## 1: The Dark Knight 153 9.0 ## 2: Schindler's List 78 8.9 ## 3: The Lord of the Rings: The Return of the King 208 8.9 ## 4: The Lord of the Rings: The Fellowship of the Ring 117 8.8 ## 5: Inception 154 8.8 ## 6: The Lord of the Rings: The Two Towers 120 8.7
Nominations Pt1
- Mean: 40.308, SD: 52.18792
Nominations Pt2
- 25 movies with 120 nominations or more
## Title Nominations imdbRating ## 1: The Dark Knight 153 9.0 ## 2: The Lord of the Rings: The Return of the King 122 8.9 ## 3: The Lord of the Rings: The Fellowship of the Ring 124 8.8 ## 4: Inception 203 8.8 ## 5: The Lord of the Rings: The Two Towers 138 8.7 ## 6: Interstellar 142 8.6
Awards and Nominations Pt1
- 34 movies with 75+ awards or 120+ nominations
## Title Awards Nominations ## 1: The Dark Knight 153 153 ## 2: Schindler's List 78 33 ## 3: The Lord of the Rings: The Return of the King 208 122 ## 4: The Lord of the Rings: The Fellowship of the Ring 117 124 ## 5: Inception 154 203 ## 6: The Lord of the Rings: The Two Towers 120 138 ## imdbRating ## 1: 9.0 ## 2: 8.9 ## 3: 8.9 ## 4: 8.8 ## 5: 8.8 ## 6: 8.7
Awards and Nominations Pt2
- 19 movies with 75+ awards and 120+ nominations
## Title Awards Nominations ## 1: The Dark Knight 153 153 ## 2: The Lord of the Rings: The Return of the King 208 122 ## 3: The Lord of the Rings: The Fellowship of the Ring 117 124 ## 4: Inception 154 203 ## 5: The Lord of the Rings: The Two Towers 120 138 ## 6: The Departed 96 134 ## imdbRating ## 1: 9.0 ## 2: 8.9 ## 3: 8.8 ## 4: 8.8 ## 5: 8.7 ## 6: 8.5
Awards and Nominations Pt3
- 9 movies with 75+ awards and 120- nominations
## Title Awards Nominations imdbRating ## 1: Schindler's List 78 33 8.9 ## 2: Saving Private Ryan 79 74 8.6 ## 3: WALL·E 91 90 8.4 ## 4: American Beauty 108 98 8.4 ## 5: L.A. Confidential 87 77 8.3 ## 6: Up 76 82 8.3 ## 7: Inside Out 93 104 8.2 ## 8: Fargo 81 59 8.1 ## 9: The Help 80 116 8.1
Awards and Nominations Pt4
- 6 movies with 75- awards and 120+ nominations
## Title Awards Nominations imdbRating ## 1: Interstellar 42 142 8.6 ## 2: Django Unchained 58 151 8.4 ## 3: The Wolf of Wall Street 38 170 8.2 ## 4: Gone Girl 64 177 8.1 ## 5: The Imitation Game 45 150 8.1 ## 6: The Martian 34 187 8.0
Genre
- Unique Genres: 24
Language Pt1
- Unique Language: 44
## x freq ## 3 Arabic 8 ## 5 Cantonese 4 ## 8 English 250 ## 10 French 41 ## 11 German 32 ## 18 Italian 17 ## 19 Japanese 6 ## 21 Latin 13 ## 31 Russian 12 ## 35 Spanish 31 ## 40 Vietnamese 4
Language Pt2
Country Pt1
- Unique Countries: 31
## x freq ## 1 Australia 6 ## 4 Canada 6 ## 7 France 12 ## 8 Germany 11 ## 12 Ireland 4 ## 13 Italy 4 ## 27 UK 55 ## 29 USA 233
Country Pt2
Correlation Pt 1
## Year Runtime Metascore imdbRating imdbVotes ## Year 1.00000000 0.17938049 -0.34085225 0.04549597 0.53623097 ## Runtime 0.17938049 1.00000000 -0.06702619 0.24776081 0.24974676 ## Metascore -0.34085225 -0.06702619 1.00000000 0.17211994 -0.09800265 ## imdbRating 0.04549597 0.24776081 0.17211994 1.00000000 0.65668014 ## imdbVotes 0.53623097 0.24974676 -0.09800265 0.65668014 1.00000000 ## BoxOffice 0.33354876 0.16853031 0.07890235 0.12349854 0.38711525 ## Awards 0.47198940 0.19118929 0.30717283 0.19979238 0.44580066 ## Nominations 0.61632678 0.18631483 0.11100696 0.08192601 0.47425298 ## BoxOffice Awards Nominations ## Year 0.33354876 0.4719894 0.61632678 ## Runtime 0.16853031 0.1911893 0.18631483 ## Metascore 0.07890235 0.3071728 0.11100696 ## imdbRating 0.12349854 0.1997924 0.08192601 ## imdbVotes 0.38711525 0.4458007 0.47425298 ## BoxOffice 1.00000000 0.1831188 0.20620724 ## Awards 0.18311879 1.0000000 0.84812343 ## Nominations 0.20620724 0.8481234 1.00000000
Correlation Pt 2
Number of Awards, BoxOffice, and imbdRatings Pt1
Number of Awards, BoxOffice, and imbdRatings Pt2
Nominations and imdbRatings Pt1
Nominations and imdbRatings Pt2
Nominations and imdbRatings Pt3
#IMBD Ratings and Production Company
ImBD Ratings and Writers
What is this????
## ## 12 Angry Men ## 1 ## 12 Years a Slave ## 1 ## 2001: A Space Odyssey ## 1 ## A Beautiful Mind ## 1 ## A Christmas Story ## 1 ## A Clockwork Orange ## 1 ## A Night at the Opera ## 1 ## A Streetcar Named Desire ## 1 ## Aladdin ## 1 ## Alien ## 1 ## Aliens ## 1 ## All About Eve ## 1 ## All Quiet on the Western Front ## 1 ## Amadeus ## 1 ## American Beauty ## 1 ## American History X ## 1 ## Anatomy of a Murder ## 1 ## Annie Hall ## 1 ## Apocalypse Now ## 1 ## Arsenic and Old Lace ## 1 ## Baby Driver ## 1 ## Back to the Future ## 1 ## Barry Lyndon ## 1 ## Batman Begins ## 1 ## Beauty and the Beast ## 1 ## Before Sunrise ## 1 ## Before Sunset ## 1 ## Ben-Hur ## 1 ## Big Fish ## 1 ## Blade Runner ## 1 ## Blood Diamond ## 1 ## Braveheart ## 1 ## Brief Encounter ## 1 ## Butch Cassidy and the Sundance Kid ## 1 ## Casablanca ## 1 ## Casino ## 1 ## Cat on a Hot Tin Roof ## 1 ## Catch Me If You Can ## 1 ## Chinatown ## 1 ## Citizen Kane ## 1 ## City Lights ## 1 ## Cool Hand Luke ## 1 ## Dead Poets Society ## 1 ## Deadpool ## 1 ## Dial M for Murder ## 1 ## Die Hard ## 1 ## Django Unchained ## 1 ## Dog Day Afternoon ## 1 ## Dogville ## 1 ## Donnie Darko ## 1 ## Double Indemnity ## 1 ## Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb ## 1 ## Eternal Sunshine of the Spotless Mind ## 1 ## Fargo ## 1 ## Fight Club ## 1 ## Finding Nemo ## 1 ## Forrest Gump ## 1 ## Full Metal Jacket ## 1 ## Gandhi ## 1 ## Gladiator ## 1 ## Gone Girl ## 1 ## Gone with the Wind ## 1 ## Good Will Hunting ## 1 ## Goodfellas ## 1 ## Gran Torino ## 1 ## Groundhog Day ## 1 ## Guardians of the Galaxy ## 1 ## Guardians of the Galaxy Vol. 2 ## 1 ## Hachi: A Dog's Tale ## 1 ## Hacksaw Ridge ## 1 ## Harry Potter and the Deathly Hallows: Part 2 ## 1 ## Harvey ## 1 ## Heat ## 1 ## High Noon ## 1 ## His Girl Friday ## 1 ## Hotel Rwanda ## 1 ## How to Train Your Dragon ## 1 ## In the Name of the Father ## 1 ## Inception ## 1 ## Indiana Jones and the Last Crusade ## 1 ## Inglourious Basterds ## 1 ## Inside Out ## 1 ## Interstellar ## 1 ## Into the Wild ## 1 ## It's a Wonderful Life ## 1 ## It Happened One Night ## 1 ## Jaws ## 1 ## JFK ## 1 ## Judgment at Nuremberg ## 1 ## Jurassic Park ## 1 ## Kill Bill: Vol. 1 ## 1 ## Kind Hearts and Coronets ## 1 ## L.A. Confidential ## 1 ## La La Land ## 1 ## Laura ## 1 ## Lawrence of Arabia ## 1 ## Léon: The Professional ## 1 ## Life of Brian ## 1 ## Lion ## 1 ## Lock, Stock and Two Smoking Barrels ## 1 ## Logan ## 1 ## Mad Max: Fury Road ## 1 ## Magnolia ## 1 ## Mary and Max ## 1 ## Memento ## 1 ## Million Dollar Baby ## 1 ## Modern Times ## 1 ## Monsters, Inc. ## 1 ## Monty Python and the Holy Grail ## 1 ## Mr. Smith Goes to Washington ## 1 ## Network ## 1 ## No Country for Old Men ## 1 ## North by Northwest ## 1 ## Notorious ## 1 ## On the Waterfront ## 1 ## Once Upon a Time in America ## 1 ## One Flew Over the Cuckoo's Nest ## 1 ## Out of the Past ## 1 ## Papillon ## 1 ## Paris, Texas ## 1 ## Paths of Glory ## 1 ## Patton ## 1 ## Pink Floyd: The Wall ## 1 ## Pirates of the Caribbean: The Curse of the Black Pearl ## 1 ## Platoon ## 1 ## Prisoners ## 1 ## Psycho ## 1 ## Pulp Fiction ## 1 ## Raging Bull ## 1 ## Raiders of the Lost Ark ## 1 ## Rain Man ## 1 ## Rear Window ## 1 ## Rebecca ## 1 ## Requiem for a Dream ## 1 ## Reservoir Dogs ## 1 ## Rio Bravo ## 1 ## Rocky ## 1 ## Roman Holiday ## 1 ## Room ## 1 ## Rope ## 1 ## Rush ## 1 ## Saving Private Ryan ## 1 ## Scarface ## 1 ## Schindler's List ## 1 ## Se7en ## 1 ## Short Term 12 ## 1 ## Shutter Island ## 1 ## Sin City ## 1 ## Singin' in the Rain ## 1 ## Sleuth ## 1 ## Sling Blade ## 1 ## Slumdog Millionaire ## 1 ## Snatch ## 1 ## Some Like It Hot ## 1 ## Song of the Sea ## 1 ## Spider-Man: Homecoming ## 1 ## Spotlight ## 1 ## Stalag 17 ## 1 ## Stand by Me ## 1 ## Star Wars: Episode IV - A New Hope ## 1 ## Star Wars: Episode V - The Empire Strikes Back ## 1 ## Star Wars: Episode VI - Return of the Jedi ## 1 ## Star Wars: The Force Awakens ## 1 ## Strangers on a Train ## 1 ## Sunset Boulevard ## 1 ## Taxi Driver ## 1 ## Terminator 2: Judgment Day ## 1 ## The Apartment ## 1 ## The Avengers ## 1 ## The Best Years of Our Lives ## 1 ## The Big Lebowski ## 1 ## The Big Sleep ## 1 ## The Bourne Ultimatum ## 1 ## The Bridge on the River Kwai ## 1 ## The Dark Knight ## 1 ## The Dark Knight Rises ## 1 ## The Deer Hunter ## 1 ## The Departed ## 1 ## The Elephant Man ## 1 ## The Exorcist ## 1 ## The General ## 1 ## The Godfather ## 1 ## The Godfather: Part II ## 1 ## The Gold Rush ## 1 ## The Graduate ## 1 ## The Grand Budapest Hotel ## 1 ## The Grapes of Wrath ## 1 ## The Great Dictator ## 1 ## The Great Escape ## 1 ## The Green Mile ## 1 ## The Help ## 1 ## The Hustler ## 1 ## The Imitation Game ## 1 ## The Kid ## 1 ## The Killing ## 1 ## The King's Speech ## 1 ## The Last Picture Show ## 1 ## The Legend of 1900 ## 1 ## The Lion King ## 1 ## The Lord of the Rings: The Fellowship of the Ring ## 1 ## The Lord of the Rings: The Return of the King ## 1 ## The Lord of the Rings: The Two Towers ## 1 ## The Lost Weekend ## 1 ## The Maltese Falcon ## 1 ## The Man Who Shot Liberty Valance ## 1 ## The Manchurian Candidate ## 1 ## The Martian ## 1 ## The Matrix ## 1 ## The Message ## 1 ## The Night of the Hunter ## 1 ## The Nightmare Before Christmas ## 1 ## The Philadelphia Story ## 1 ## The Pianist ## 1 ## The Prestige ## 1 ## The Princess Bride ## 1 ## The Revenant ## 1 ## The Shawshank Redemption ## 1 ## The Shining ## 1 ## The Silence of the Lambs ## 1 ## The Sixth Sense ## 1 ## The Sting ## 1 ## The Straight Story ## 1 ## The Terminator ## 1 ## The Thing ## 1 ## The Third Man ## 1 ## The Treasure of the Sierra Madre ## 1 ## The Truman Show ## 1 ## The Usual Suspects ## 1 ## The Wild Bunch ## 1 ## The Wizard of Oz ## 1 ## The Wolf of Wall Street ## 1 ## There Will Be Blood ## 1 ## To Kill a Mockingbird ## 1 ## Touch of Evil ## 1 ## Toy Story ## 1 ## Toy Story 3 ## 1 ## Trainspotting ## 1 ## Twelve Monkeys ## 1 ## Unforgiven ## 1 ## Up ## 1 ## V for Vendetta ## 1 ## Vertigo ## 1 ## WALL·E ## 1 ## Warrior ## 1 ## What Ever Happened to Baby Jane? ## 1 ## Whiplash ## 1 ## Who's Afraid of Virginia Woolf? ## 1 ## Witness for the Prosecution ## 1 ## Young Frankenstein ## 1 ## Zootopia ## 1
ImdbRating and Runtime
- Correlation Coefficient: 0.248
Awards and Production
Award and imdbRating
- Correlation Coefficient: 0.200
